/* =====================================================================================
/   TABLE: [BlogCategories]
/  ===================================================================================== */

if exists (select * from [dbo].sysobjects where id = object_id(N'[dbo].[BlogCategories]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[BlogCategories]

GO

/* =====================================================================================
/   TABLE: [BlogPosts]
/  ===================================================================================== */

if exists (select * from [dbo].sysobjects where id = object_id(N'[dbo].[BlogPosts]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[BlogPosts]

GO

/* =====================================================================================
/   TABLE: [BlogPostCategory]
/  ===================================================================================== */

if exists (select * from [dbo].sysobjects where id = object_id(N'[dbo].[BlogPostCategory]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[BlogPostCategory]

GO

/* =====================================================================================
/   TABLE: [BlogPostComment]
/  ===================================================================================== */

if exists (select * from [dbo].sysobjects where id = object_id(N'[dbo].[BlogPostComment]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[BlogPostComment]

GO

/* =====================================================================================
/   TABLE: [BlogPostNotify]
/  ===================================================================================== */

if exists (select * from [dbo].sysobjects where id = object_id(N'[dbo].[BlogPostNotify]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[BlogPostNotify]

GO

/* =====================================================================================
/   TABLE: [BlogPostTag]
/  ===================================================================================== */

if exists (select * from [dbo].sysobjects where id = object_id(N'[dbo].[BlogPostTag]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[BlogPostTag]

GO

